if exists (select * from dbo.sysobjects where id = object_id(N'dbo.SelectChangeTransactions') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SelectChangeTransactions

GO

CREATE PROCEDURE dbo.SelectChangeTransactions
	@tranCount bigint
AS

SET ROWCOUNT @tranCount

SELECT [ID]
      ,[TableName]
      ,[UserName]
      ,[HostName]
      ,[AppName]
      ,[ChangeDate]
      ,[Spid]
FROM dbo.[ChangeTransaction] --WITH(READPAST)
ORDER BY ID